﻿CREATE PROCEDURE [dbo].[yaf_forumaccess_list](
                @ForumID INT)
AS
    BEGIN
        SELECT a.*,
               GroupName = b.Name
        FROM   yaf_ForumAccess a,
               yaf_Group b
        WHERE  a.ForumID = @ForumID
        AND b.GroupID = a.GroupID
    END


